Financial data entry system

ABSTRACT

A method of tracking and aggregating all Securities and Exchange Commission (SEC) “shelf” registration and all capital market activity related to those shelf registrations. The method includes the steps of accessing a first database containing data associated with investment registrations, wherein the data is organized as a series of individual filings. The method further includes the steps of retrieving data from the first database associated with selected ones of the filings, organizing the data into tables based on at least one aggregate aspect of the data common to multiple filings, and storing the retrieved data in at least one table.

CROSS-REFERENCE TO RELATED APPLICATIONS

This is a Continuation of application Ser. No. 12/720,240 filed Mar. 9,2010, which in turn is a Continuation of application Ser. No. 11/611,380filed Dec. 15, 2006, which claims the benefit of U.S. ProvisionalApplications No. 60/597,652 filed Dec. 15, 2005. The disclosure of theprior applications is hereby incorporated by reference herein in itsentirety.

TECHNICAL FIELD AND BACKGROUND OF THE INVENTION

The present invention relates to the field of computer databases. Inparticular, the invention relates to a software interface and databasethat tracks and aggregates all Securities and Exchange Commission (SEC)“shelf” registration and all capital market activity related to thoseshelf registrations.

Shelf registration refers to the registration of securities, under SECrule 415, that are not to be presently offered for sale. SEC rule 415allows issuers to register securities (such as Equity, Fixed Income, andUniversal) for an offering to be made on a continuous or delayed basis.That is, the securities are being registered so they can be placed “onthe shelf” until the time comes for issuance. The shelf registrationsmay be primary or secondary or both.

Issuers use a two year window to speculate on capital markets activity,and to determine the types of securities that the issuers will useduring this time to raise capital. Issuers that qualify as well-knownseasoned issuers (wksi) file an unlimited shelf every three years toraise capital. Shelf registrations allow corporations to defer the saleof securities after registration until funds are needed or marketconditions are favorable. Although, shelf registration permits acorporation to place the sell of shares on standby, it must still filethe required annual and quarterly reports to the SEC.

Capital market activity relative to the shelf is called a “takedown.”Takedown is a term that refers to underwriters taking securities off theshelf. For example, a company files a five billion dollar shelf andlater decides to sell one billion dollars worth of investment gradebonds. In this case, an underwriter has performed a one billion dollarshelf takedown and has left four billion dollars remaining on the shelf.

Shelf registrations and takedowns are a common occurrence in the marketplace, and represent a substantial portion of capital markets activity.It is important for bankers to keep track of shelf registrations andtakedowns so that they know the value and or the types of securitiesavailable for issuance. For the investment banking divisions of banks,keeping track of shelf registrations and takedowns is a very difficultand time consuming undertaking. Couple this with analyzing the company'sstock performance relative to this activity and a considerable outlay ofresources is required.

Accordingly, there is a need for a software and database system that canpopulate a database table with the appropriate data to be used in anapplication tracking and analyzing these financial transactions.

SUMMARY OF THE INVENTION

Therefore it is an object of the invention to provide a software anddatabase system that tracks and aggregates all SEC shelf registrations.

It is another object of the invention to provide a software and databasesystem that tracks and aggregates all capital market activity related toan SEC shelf registration.

It is another object of the invention to provide a software and databasesystem that tracks and aggregates all issuers and subsidiaries relatedto an SEC shelf registration.

It is another object of the invention to provide a software and databasesystem that tracks all selling shareholders who register shares underthese shelf offerings.

It is another object of the invention to provide a software and databasesystem that tracks stock performance relative to capital marketsactivity.

These and other objects of the present invention are achieved in thepreferred embodiments disclosed below by providing a method of trackinginvestment registrations including the steps of accessing a firstdatabase containing data associated with investment registrations,wherein the data is organized as a series of individual filings. Themethod further including retrieving data from the first databaseassociated with selected ones of the filings, organizing the data intotables based on at least one aggregate aspect of the data common tomultiple filings, and storing the retrieved data in at least one table.

According to another preferred embodiment of the invention, the step ofretrieving data includes the step of searching by a company ticker.

According to another preferred embodiment of the invention, the step ofretrieving data includes the step of searching by an issuer name.

According to another preferred embodiment of the invention, the methodfurther includes the step of linking parent companies to theirrespective subordinate companies.

According to another preferred embodiment of the invention, the methodfurther includes the step of tracking common stock associated with thefilings.

According to another preferred embodiment of the invention, the methodfurther includes the step of tracking a performance of the common stock.

According to another preferred embodiment of the invention, the methodfurther includes the step of tracking a takedown relative to thefilings.

According to another preferred embodiment of the invention, the methodfurther includes the step of subtracting a respective takedown from acorresponding linked shelf filing.

According to another preferred embodiment of the invention, the methodfurther includes the step of updating the data.

According to another preferred embodiment of the invention, the methodfurther includes the step of updating the data when a takedown relativeto the filings has occurred.

According to another preferred embodiment of the invention, the methodfurther includes the step of automatically updating the data.

According to another preferred embodiment of the invention, the methodfurther includes the step of searching a data entry system forpreviously downloaded data relating to a respective shelf filing.

According to another preferred embodiment of the invention, the methodfurther includes the step of updating the data by searching for marketactivity relating to the shelf filing and downloading the data into thedata entry system.

According to another preferred embodiment of the invention, the methodfurther includes the step of generating a report in a format suitablefor investment banking.

According to another preferred embodiment of the invention, a computerimplemented system for tracking investment registrations includes anaccessing means for accessing a first database containing dataassociated with investment registrations, wherein the data is organizedas a series of individual filings; a retrieving means for retrievingdata from the first database associated with selected ones of thefilings; an organizing means for organizing the data into tables basedon at least one aggregate aspect of the data common to multiple filings;and a storing means for storing the retrieved data in at least onetable.

According to another preferred embodiment of the invention, a computerreadable medium is provided that includes software for trackinginvestment registrations. The software includes instructions foraccessing a first database containing data associated with investmentregistrations, wherein the data is organized as a series of individualfilings. The software further includes instructions for retrieving datafrom the first database associated with selected ones of the filings;organizing the data into tables based on at least one aggregate aspectof the data common to multiple filings; and storing the retrieved datain at least one table.

According to another preferred embodiment of the invention, the softwarefurther includes instructions for tracking performance of common stockassociated with the filings.

According to another preferred embodiment of the invention, the softwarefurther includes instructions for linking parent companies to theirrespective subordinate companies.

According to another preferred embodiment of the invention, the softwarefurther includes instructions for tracking a takedown relative to thefilings.

According to another preferred embodiment of the invention, the softwarefurther includes instructions for subtracting the takedown from acorresponding linked filing.

According to another preferred embodiment of the invention, the softwarefurther includes instructions for updating the data in the tables inresponse to the takedown.

According to another preferred embodiment of the invention, the softwarefurther includes instructions for retrieving data associated withpreviously retrieved data relating to a respective one of the filings.

According to another preferred embodiment of the invention, the softwarefurther includes instructions for monitoring market activity relating tothe filings.

BRIEF DESCRIPTION OF THE DRAWINGS

The invention may be best understood by reference to the followingdescription in conjunction with the accompanying drawing figures inwhich:

FIG. 1 is a flow diagram according to an embodiment of the invention;

FIG. 2 is a login screen image;

FIG. 3 is a main menu screen image;

FIG. 4 is a select deal screen image;

FIG. 5 is a shelf filing screen image;

FIG. 6 is a select issuer screen image;

FIG. 7 is an add/edit issuer screen image;

FIG. 8 is an equity takedown screen image;

FIG. 9 is a convertible takedown screen image; and

FIG. 10 is a fixed income takedown screen image.

DESCRIPTION OF THE PREFERRED EMBODIMENT AND BEST MODE

Referring now specifically to the drawings, a software and databasesystem according to an embodiment of the invention is illustrated inFIG. 1 and shown generally at reference numeral 10.

The system uses a class 3 tier system with an application serviceprovider (ASP) front end, C# business logic, and a structured querylanguage (SQL) server 2000 back end. The ASP is used to capture andpresent data, while all data manipulations and error checking are donein C#. Other suitable programming packages may also be used.

The system 10 provides the ability to search by ticker or issuer nameand track all shelf registrations. It also stores data points per filingand per deal into a structured database, provides tools for analyzingdata and creating reports, links parent companies to all subordinatecompanies, provides breakdown and roll up of parent-child shelfregistrations, aggregates data into formats conducive to prospecting forinvestment banking, tracks common stock and common stock versus S&P 500Index performance relative to shelf takedowns to help analyze theeffects of capital placement, and provides tools so that customers canmap issuers to their own custom sector and industry groups.

In use, the system 10 provides a user with various screens to guide theuser through the system 10. First, the user is presented with a loginscreen, shown in FIG. 2, to allow the user to login to the system 10.Once the username and password have been entered and the login buttonhas been clicked, the username and password is checked against a USERStable, such as the one shown below in Table 1.

TABLE 1 Owner: Target DB name: Number of columns: 5 Number of indexes: 0Number of foreign keys: 0 Columns Data type Allow NULLs Value/RangeUserID int identity Not allowed Name varchar(200) Not allowed Emailvarchar(200) Allowed Password varchar(200) Not allowed Service_Levelvarchar(200) Not allowed

If their USERS.Service=ADMIN, then they are forwarded on to the mainmenu and a session is started. If their USERS.Service does not equalADMIN then they are returned to the login page.

Once the user has logged into the system 10, the user is presented witha main menu screen, as shown in FIG. 3. The main menu allows the user toadd, edit, or delete all four types of deals (shelf, equity, debt, andconvertible) through the use of hyperlinks. If the user wants to edit ordelete a deal, the user clicks on the “Select Deal” hyperlink. If theuser wants to add a deal, the user clicks on the hyperlink related tothe type of deal being entered.

If the user selects the Select Deal hyperlink on the main menu, a popupscreen, shown in FIG. 4, appears. The popup screen allows the user toselect a deal then edit it. The popup screen will initially have nodeals listed when loaded. Pull down menus are used to accept argumentsto restrict the list and to further cut down the number of deals shownon the screen. Possible arguments include SHELF, EQUITY, FIXED INCOME,and CONVERTIBLE. Other drop down options include “Issuer Name” and“Filing Date.” Another pull down menu allows the user to select EQUALS,CONTAINS, GREATER THAN, and LESS THAN. Once the drop down menus havebeen selected and the submit button has been clicked, an SQL serversearch is run. The SQL server statement querying the deal will bemodified depending on the arguments passed to it and the drop downmenus. Once a deal number has been selected by clicking on the issuername, the popup will close and the main window will then be forwarded tothe correct “Add/Edit” screen with the deal number added as an argument.

If the user selects one of the “Add Deal” hyperlinks (Shelf Filing,Equity, Convertible, and Fixed Income), the user is directed to thecorrect Add/Edit screen for the respective deal type selected. Forexample, if the user selects the “Shelf Filing” hyperlink, the user isdirected to an Add/Edit screen for Shelf Filing. When adding a deal, theuser searches the SEC's Electronic Data Gathering, Analysis, andRetrieval system (EDGAR) for company filings. Once the desired filing islocated, the data associated with that filing, including data fromassociated filings, is pulled into the system. This data is continuallyupdated.

If the Shelf Filing hyperlink is selected, the Add/Edit screen, shown inFIG. 5, is presented. The Shelf Filing screen allows the user to add,edit, or delete a shelf filing. The screen is capable of using the dealnumber provided by the Select Deal popup screen as an argument. If adeal number is provided, the deal information is prepopulated. If a dealnumber is not provided, the user can populate the table using otherlinks, such as “Select Issuer” and “Add Selling Shareholder.”

If the Select Issuer hyperlink is selected, a Select Issuer popup screenappears, shown in FIG. 6. The Select Issuer screen is used to populateissuer information for each deal. The Select Issuer screen performs anSQL server search using an issuers table like the one shown below inTable 2.

TABLE 2 Owner: Target DB name: Number of columns: 9 Number of indexes: 0Number of foreign keys: 5 Columns Data type Allow NULLS Value/RangeIssuerID int identity Not allowed Issuer_Name varchar(200) Not allowedWebsite varchar(200) Allowed SIC_Code (FK) int Allowed ExchangeID (FK)int Allowed Ticker varchar(20) Allowed NationalityID (FK) int AllowedSectorID (FK) int Allowed IndustryID (FK) int Allowed Foreign keys childParent tbl_SIC_tbl_Issuer_FK1 SIC_Code tbl_SIC.SIC_codetbl_Exchange_tbl_Issuer_FK1 ExchangeID tbl_Exchange.ExchangeIDtbl_Nationality_tbl_Issuer_FK1 NationalityIDtbl_Nationality.NationalityID tbl_Industry_tbl_Issuer_FK1 IndustryIDtbl_Industry.IndustryID tbl_Sector_tbl_Issuer_FK1 SectorIDtbl_Sector.SectorID tbl_Issuer_tbl_SHELF_FK1 tbl_SHELF.IssuerID IssuerIDtbl_Issuer_tbl_ EQUITY_FK1 tbl_EQUITY.IssuerID IssuerIDtbl_Issuer_tbl_CONVERTIBLE_FK1 tbl_CONVERTIBLE.IssuerID IssuerIDtbl_Issuer_tbl_FIXEDINCOME_FK1 tbl_FIXEDINCOME.IssuerID IssuerID

Drop down menus allow the user to restrict the search. The first dropdown menu includes the options of “Issuer Name” and “Ticker.” The seconddrop down menu options are EQUALS and CONTAINS. When an issuer isselected, the window will close the main Shelf Filing screen willpopulate with that issuer.

If the user is not able to find the issuer they are looking for, theycan click the “Add Issuer” link and it will forward them to the Add/EditIssuer screen, shown in FIG. 7, with no arguments passed to it. TheAdd/Edit Issuer screen allows the user to add/edit an issuer. If thescreen is loaded with an Issuer ID passed to it, then all of theinformation will be prepopulated. If the screen is called with noarguments, then the user will have to add the issuer. In this case, thescreen will be empty and issuer ID will have a non-editable “New Issuer”tag. When the Save and Select button is selected, the user is returnedto the Shelf Filing screen with this issuer selected.

The Shelf Filing screen also allows underwriter information to be addedby selecting the “Add Selling Shareholder” link or deleted by selectingthe remove link. Once a deal has been selected, specific checks are madeagainst the data after it is entered to make sure it is in the correctformat. Any error messages may be provided in red at the top of thescreen, listing everything that is incorrect before the deal can besaved or updated in a shelf database like the one shown below in Table3.

TABLE 3 Owner: Target DB name: Number of columns: 40 Number of indexes:0 Number of foreign keys: 1 Columns Data type Allow NULLs Value/RangeDeal int Not allowed IssuerID (FK) int Not allowed Link_1 varchar(200)Allowed Link_2 varchar(200) Allowed Link_3 varchar(200) AllowedFiling_Form varchar(20) Allowed Filing_Date datetime Allowed Rule_415_YNvarchar(1) Allowed Rule_462_YN varchar(1) Allowed Rule_429_YN varchar(1)Allowed Security_Class varchar(20) Allowed Value decimal(12.2) AllowedEquity_Value decimal(12.2) Allowed Debt_Value decimal(12.2) AllowedOther_Value decimal(12.2) Allowed Primary_Value decimal(12.2) AllowedSecondary_Value decimal(12.2) Allowed Primary_Shares int AllowedSecondary_Shares int Allowed Last_Trade_before_file decimal(12.3)Allowed Purpose varchar(50) Allowed Type varchar(50) Allowed Shelf_Notevarchar(1000) Allowed Use_Proceeds varchar(1000) Allowed LT_Debtdecimal(15.3) Allowed Common_Stock_Authorized int AllowedCommon_Stock_Outstanding int Allowed Common_Stock_Issued int AllowedPreferred_Stock_Authorized int Allowed Preferred_Stock_Outstanding intAllowed Preferred_Stock_Issued int Allowed Restricted_Stock_Authorizedint Allowed Restricted_Stock_Outstanding int AllowedRestricted_Stock_Issued int Allowed Shareholders_Equity decimal(15.3)Allowed Stock_Units_Authorized int Allowed Stock_Units_Outstanding intAllowed Stock_Units_Issued int Allowed Takedown_YN varchar(1) AllowedRevised_Value decimal(12.2) Allowed Foreign keys Child Parenttbl_Issuer_tbl_SHELF_FK1 IssuerID tbl_Issuer.IssuerID

If the Equity, Convertible, or Fixed Income hyperlink is selected, anAdd/Edit screen for the selected link is presented. FIGS. 8, 9, and 10are representative of screens related to the hyperlinks. Like the ShelfFiling screen, the Equity, Convertible, and Fixed Income screens arecapable of using the deal number provided by the Select Deal popupscreen as an argument. If a deal number is provided, the dealinformation is prepopulated. If a deal number is not provided, the usercan populate the table using other links. The Equity, Convertible, andFixed Income screens operate in the same manner, thus, only the EquityTakedown screen will be discussed in detail.

The Equity Takedown screen, shown in FIG. 8, allows the user to add,edit, or delete an equity takedown. The Select Shelf hyperlink links tothe Select Deal screen passing it the argument to only look for Shelfdeals, so that only Shelf deals appear for selection. This allows thetakedown and shelf filings to be linked so that the system automaticallysubtracts the amount of the takedown from the original shelf, allowing auser to keep track of how much of the shelf is remaining for futurecapital issuance. Once a shelf is selected, it will populate the otherinformation on that section. Underwriters are added by selecting the“Add Bank” link that brings up an “Add Bank” screen (not shown) to allowthe user to add a bank and its role to the list. Specific checks againstthe data after it is entered is then performed. Any error messages maybe in red at the top of the page, listing everything that is incorrectbefore the deal is saved or update in an Equity database like the oneshown below in Table 4.

TABLE 4 Target DB name: Number of columns: 31 Number of indexes: 0Number of foreign keys: 1 Columns Data type Allow NULLs Value/Range Dealint Not allowed Shelf int Not allowed IssuerID (FK) int Not allowedLink_1 varchar(200) Allowed Link_2 varchar(200) Allowed Link_3varchar(200) Allowed Form varchar(20) Allowed Filing_Date datetimeAllowed Shares_Registered int Allowed Shares_Issued int AllowedShares_Secondary int Allowed Shares_Primary int Allowed Pricedecimal(10.3) Allowed Security_Class varchar(100) Allowed Interestdecimal(10.3) Allowed Lock_Up int Allowed Note varchar(1000) AllowedDebt_Total decimal(12.3) Allowed Shares_Outstanding int AllowedShares_Outstanding_TD int Allowed Overallotment_Authorized int AllowedOverallotment_Price_Date datetime Allowed Overallotment_Shares_Issueddatetime Allowed Gross_Spread_Share decimal(12.3) AllowedGross_Spread_Total decimal(12.3) Allowed Proceeds_Share decimal(12.3)Allowed Proceeds_Total decimal(12.3) Allowed Proceeds_Use varchar(1000)Allowed LastTrade_Before_File decimal(12.3) Allowed Price_Date datetimeAllowed LastTrade_Before_Price decimal(12.3) Allowed Foreign keys ChildParent tbl_Issuer_tbl_EQUITY_FK1 IssuerID tbl_Issuer.IssuerID

The information may then be saved, cancelled, or deleted. When the savebutton is selected, the data is updated for an existing deal and addedfor a new deal. When the delete button is selected, the deal number fromthe Equity database, as well as, rows in a “Deal Bank” database withthat deal number are deleted.

The Convertible Takedown screen, shown in FIG. 9, allows the user toadd, edit, or delete a convertible takedown, and the Fixed IncomeTakedown screen, shown in FIG. 10, allows the user to add, edit, ordelete a fixed income takedown. When the save button is selected, thedata is updated for an existing deal and added for a new deal. When thedelete button is selected, the deal number is deleted from a Convertibleand Fixed Income table, as well as, all rows in the Deal Bank databaseand a “Deal Selling Shareholder” database with that deal number.

In addition to adding, editing, and deleting shelf filings andtakedowns, the system 10 allows a user to run queries on specificfilings. This allows a user to analyze the data for specific filings.For example, a user may want to analyze the performance of a filing withrespect to the market. The system 10 also allows a user to createreports for use by bankers and other individuals in the investmentworld.

A software and database system is described above. Various details ofthe invention may be changed without departing from its scope.Furthermore, the foregoing description of the preferred embodiments ofthe invention and best mode for practicing the invention are providedfor the purpose of illustration only and not for the purpose oflimitation.

What is claimed is:
 1. A computerized method of tracking investmentregistrations, comprising: receiving individual filings of investmentregistrations of entities, from a first database located remote from acomputer over a network; storing, in a shelf database, initial shelfregistration entries with entity identifiers associated with respectiveentities; receiving, via the computer, subsequent filings from theentity identifiers and linking the subsequent filings to: shelf, equityor debt databases of that particular shelf from equity and debtdatabases after the individual filings are received; identifying, viathe computer, if there are subsequent filings for each of the respectiveentities using data received from the equity and debt databasesidentifying each of the subsequent filings entries in association withthe respective entities in response to determining that there aresubsequent filings for the respective entities; determining a type ofthe subsequent filings for each subsequent filing for each respectiveentity; tracking shelf investment registrations of a particular entityby organizing the retrieved data associated with a shelf filing or shelftakedown of the particular entity so that a total shelf capacity ortotal take-down for the particular entity is determined; calculating aremaining shelf capacity relative to the shelf capacity value for theparticular entity based on the determined type of the subsequent filingsof the particular entity comprising: subtracting each subsequent filingsvalue from the shelf capacity value for each subsequent filing inresponse to determining that the filing is a shelf takedown; and storinga total shelf capacity in a storage database so that a searcher canquery the storage database to determine the total shelf capacity of anentity or total take-downs of the entity.
 2. The method according toclaim 1, further comprising: in response to determining that the filingof a particular entity is a shelf filing, selecting the particularentity associated with that filing, wherein the particular entitycomprises an issuer associated with the filing.
 3. The method accordingto claim 2, further comprising: in response to determining that thefiling of the particular entity is a shelf takedown, determining aregistration of the shelf takedown.
 4. The method according to claim 1,further comprising: displaying all shelf registrations and subsequentfilings associated with the entity.
 5. The method according to claim 1,wherein the subsequent filings comprise at least one of a shelf takedownor selling securities.
 6. The method according to claim 1, wherein theretrieving data includes the step of searching by a company ticker. 7.The method according to claim 1, wherein the retrieving data includesthe step of searching by an issuer name.
 8. The method according toclaim 1, wherein the retrieving data includes the step of searching bysector or industry.
 9. The method according to claim 1, and furtherincluding linking parent companies to their respective subordinatecompanies.
 10. The method according to claim 1, further includingtracking common stock associated with the filings.
 11. The methodaccording to claim 1, and further including updating the data when atakedown relative to the filings has occurred.
 12. The method accordingto claim 1, further including searching a data entry system forpreviously downloaded data relating to a respective shelf filing. 13.The method according to claim 1, further including updating the data bysearching for market activity relating to the shelf filing anddownloading the data into the data entry system.
 14. The methodaccording to claim 1, further including organizing shelf takedowns byregistration of each respective takedown.
 15. A non-transitory computerreadable medium having computer-executable instructions embedded thereinfor tracking investment registrations, the computer-executableinstructions are configured for executing a method, the methodcomprising: receiving individual filings of investment registrations ofentities, from a first database located remote from a computer over anetwork; storing, in a shelf database, initial shelf registrationentries with entity identifiers associated with respective entities;receiving, via the computer from equity and debt databases, subsequentfilings after the individual filings are received; identifying, via thecomputer, if there are subsequent filings for each of the respectiveentities using data received from the equity and debt databasesidentifying each of the subsequent filings entries in association withthe respective entities using respective entity identifiers in responseto determining that there are subsequent filings for the respectiveentities; determining a type of the subsequent filings for eachsubsequent filing for each respective entity; tracking shelf investmentregistrations of a particular entity by organizing the retrieved dataassociated with a shelf filing or shelf takedown of the particularentity so that a total shelf capacity or total take-down for theparticular entity is determined; calculating a remaining shelf capacityrelative to the shelf capacity value for each respective entity based onthe determined type of the subsequent filings of the respective entitiescomprising: subtracting each subsequent filings value from the shelfcapacity value for each subsequent filing in response to determiningthat the filing is a shelf takedown; and storing a total shelf capacityin a storage database so that a searcher can query the storage databaseto determine the total shelf capacity of an entity or total take-downsof the entity.
 16. The computer readable medium including softwareaccording to claim 15, the method further including tracking a takedownrelative to the filings and subtracting the takedown from acorresponding linked filing.
 17. The computer readable medium includingsoftware according to claim 15, and further including instructions forgenerating a report in a format suitable for investment banking.